﻿j/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

USE [AGApps]
GO
SET IDENTITY_INSERT [dbo].[App] ON 

INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (1, N'SharePoint Object Explorer', N'SPOE')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (2, N'SharePoint File Explorer', N'SPFE')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (3, N'SharePoint Permission Explorer', N'SPPE')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (4, N'ODATA QueryBuilder', N'ODQB')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (5, N'Stelling van de dag', N'SVDD')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (6, N'Buienradar', N'BRDR')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (7, N'YouTube', N'YOTU')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (8, N'AdRotator', N'ADRO')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (9, N'www.arthurgraus.nl', N'ARGR')

INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (10, N'Poll App SharePoint', N'PLSP')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (11, N'Poll App Excel', N'PLXL')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (12, N'Poll App PowerPoint', N'PLPP')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (12, N'Poll App PowerPoint', N'PLPP')
INSERT [dbo].[App] ([AppId], [AppName], [AppCode]) VALUES (13, N'SharePoll', N'SHPL')



SET IDENTITY_INSERT [dbo].[App] OFF

SET IDENTITY_INSERT [dbo].[Ad] ON 
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (1, 
												N'//arthurgraus.s3.amazonaws.com/SharePointPermissionExplorerAd.png', 
												N'http://www.arthurgraus.nl/sharepoint-apps/sharepoint-permission-explorer', N'', 0, '')
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (2, 
												N'//arthurgraus.s3.amazonaws.com/SharePointObjectExplorerAd.png', 
												N'http://office.microsoft.com/en-us/store/sharepoint-object-explorer-WA104055379.aspx', N'', 0 , '')

INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (3, 
												N'//arthurgraus.s3.amazonaws.com/ZelfAppsLerenBouwen.png', 
												N'http://www.arthurgraus.nl/training/sharepoint2013developmentupdate', N'nl-nl,nl-be',0,'')

INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (4, 
												N'//arthurgraus.s3.amazonaws.com/SharePointVideos.png', 
												N'http://www.1shoppingcart.com/app/?af=1570092', N'',0,'')

--http://www.sharepointads.com/members/affiliates/login.php

--http://apps.arthurgraus.nl/Handlers/GetImage.ashx?ImageURL=
--http://meyerweb.com/eric/tools/dencoder/



--Upload Multiple Files to SharePoint" title="Upload Multiple Files to SharePoint
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (6, 
												N'', 
												N'', N'',1,
'<a href="http://sharepointads.com/members/scripts/click.php?a_aid=ArthurGraus&amp;a_bid=cfbaeab6&amp;a_rid=d4715a85" target="_blank"><img border="0" src="http://apps.arthurgraus.nl/Handlers/GetImage.ashx?ImageURL=http%3A%2F%2Fsharepointads.com%2Fmembers%2Faccounts%2Fdefault1%2Fbanners%2FLacun%20Drop%20It%20729x79.png" alt="Upload Multiple Files to SharePoint" title="Upload Multiple Files to SharePoint" width="729" height="79"></a>')
--Data Connector by BoostSolutions
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (7, 
												N'', 
												N'', N'',1,
'<a href="http://sharepointads.com/members/scripts/click.php?a_aid=ArthurGraus&amp;a_bid=29dc7ae4&amp;a_rid=d4715a85" target="_blank"><img border="0" src="//apps.arthurgraus.nl/Handlers/GetImage.ashx?ImageURL=http%3A%2F%2Fwww.sharepointads.com%2Fmembers%2Faccounts%2Fdefault1%2Fbanners%2Fbanner_729x79.png" alt="Data Connector by BoostSolutions" title="Data Connector by BoostSolutions" width="729" height="79"></a>')

--SP Workflows
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (8, 
												N'', 
												N'', N'',1,
'<a href="http://www.sharepointads.com/members/scripts/click.php?a_aid=ArthurGraus&amp;a_bid=0e00c118&amp;a_rid=d4715a85" target="_blank"><img border="0" src="//apps.arthurgraus.nl/Handlers/GetImage.ashx?ImageURL=http%3A%2F%2Fwww.sharepointads.com%2Fmembers%2Faccounts%2Fdefault1%2Fbanners%2Fbanner_729x79.png" alt="SharePoint Workflows" title="SharePoint Workflows" width="729" height="79"></a>')

-- C0ntent Organizer
INSERT [dbo].[Ad] ([AdId], [ImageUrl], [TargetUrl], [Languages], [IsHTML], [HTML]) VALUES (9, 
												N'', 
												N'', N'',1,
'<a href="http://www.sharepointads.com/members/scripts/click.php?a_aid=ArthurGraus&amp;a_bid=3ca842b0&amp;a_rid=d4715a85" target="_blank"><img border="0" src="//apps.arthurgraus.nl/Handlers/GetImage.ashx?ImageURL=http%3A%2F%2Fsharepointads.com%2Fmembers%2Faccounts%2Fdefault1%2Fbanners%2F730x80.png" alt="SharePoint Migration" title="SharePoint Migration" width="729" height="79"></a>')




SET IDENTITY_INSERT [dbo].[Ad] OFF

DELETE FROM [dbo].[AppAd]

--Object Explorer
--INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (1, 1, 1)
--INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (1, 3, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (1, 7, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (1, 8, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (1, 9, 1)

--File Explorer
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (2, 1, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (2, 2, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (2, 3, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (2, 4, 1)

INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (2, 6, 2)


INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (3, 2, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (3, 3, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (3, 4, 1)

--ODATA QueryBuilder
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (4, 7, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (4, 8, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (4, 9, 1)

INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (5, 4, 1)

--Buienradar
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (6, 6, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (6, 9, 1)

--YouTube
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (7, 6, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (7, 9, 1)


INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (8, 4, 1)

--SharePoll
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (13, 6, 1)
INSERT [dbo].[AppAd] ([AppId], [AdId], [Location]) VALUES (13, 9, 1)